Spreadsheets can be used for more than just creating tables and charts and
summarizing data. Instead of just storing, summarizing, and formatting data, a financial
model is used for analysis. Spreadsheets are now commonly used for creating complex
mathematical models. In this course, we will explain how to build financial models in
Excel by provides instructions, not templates. We will learn to develop value-added skills
in spreadsheet modeling of financial applications.
This is a course emphasizing on learning by doing. What you learn from this course
will be very important for your career. The major software used in this course is Excel.
We are going to use Excel as a tool to solve financial problems. Financial issues to be
covered are capital budgeting, financial statement analysis, portfolio analysis, capital
structure, dividend policy, bond management, option pricing, and option trading strategy.
Excel functions and tools, such as Data Table, Goal seeker, Solver etc. will be used
intensively. Programming a VBA macro is an important task in this course.
After finishing this course, you can put the following statement, “Excel Expert”, on
your resume and get a good job.
Class Schedule
Week Date Contents
1 Introduction
2 Financial ratio analysis
3 Capital budgetin
4 Sensitivity analysis, Scenario analysis, Simulation
5 Statistics analysis and matrix operation
6 Portfolio analysis
7 Optimal Capital structure
8 Midterm examination
9 Dividends Policy and practice
10 Interest rate models
11 Bond pricing and risk management
12 Option pricing: Black-Scholes model
13 Option pricing: Binominal model
14 Option trading strategy
15 Pivot tables
16 Final examination
* Students with disability should come to me for appropriate arrangements.
* I reserve the right to change the above contents.